Home | Help | Contact Us

# SQL, PL/SQL, and SQL*Plus Syntax and Examples: D

### Shortcuts to Items in the List

% | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X

DA | DB | DE | DF | DI | DL | DO | DR | DU | DY

### Statements, Keywords, Packages, and Functions

#### DATABASE: Definition

#### DATABASE Clause: Definition

#### DATABASE_TRACE_DISABLE Procedure: Definition

#### DATABASE_TRACE_ENABLE Procedure: Definition

#### DATAFILE 'filename': Definition

#### DATAFILE Clause: Definition

#### DATAFILE | TEMPFILE Clause: Definition

#### DATA_BLOCK_ADDRESS_BLOCK Function: Definition

#### DATA_BLOCK_ADDRESS_FILE Function: Definition

#### DATA_FILTER Procedures: Definition

#### DATE Datatype: Definition

#### DATE Values: Definition

#### DATE_TABLE: Definition

#### DBA_RECYCLEBIN: Definition

#### DBMS_ADVANCED_REWRITE: Definition

#### DBMS_ADVISOR: Definition

#### DBMS_ALERT: Definition

#### DBMS_APPLICATION_INFO: Definition

#### DBMS_APPLY_ADM: Definition

#### DBMS_AQ: Definition

#### DBMS_AQADM: Definition

#### DBMS_AQELM: Definition

#### DBMS_AQIN: Definition

#### DBMS_CAPTURE_ADM: Definition

#### DBMS_CDC_PUBLISH: Definition

#### DBMS_CDC_SUBSCRIBE: Definition

#### DBMS_CHANGE_NOTIFICATION: Definition

#### DBMS_CRYPTO: Definition

#### DBMS_DATAPUMP: Definition

#### DBMS_DATA_MINING: Definition

#### DBMS_DATA_MINING_TRANSFORM: Definition

#### DBMS_DB_VERSION: Definition

#### DBMS_DDL: Definition

#### DBMS_DEBUG: Definition

#### DBMS_DEFER: Definition

#### DBMS_DEFER_QUERY: Definition

#### DBMS_DEFER_SYS: Definition

#### DBMS_DESCRIBE: Definition

#### DBMS_DIMENSION: Definition

#### DBMS_DISTRIBUTED_TRUST_ADMIN: Definition

#### DBMS_EPG: Definition

#### DBMS_ERRLOG: Definition

#### DBMS_EXPFIL: Definition

#### DBMS_FGA: Definition

#### DBMS_FILE_GROUP: Definition

#### DBMS_FILE_TRANSFER: Definition

#### DBMS_FLASHBACK: Definition

#### DBMS_FREQUENT_ITEMSET: Definition

#### DBMS_HS_PASSTHROUGH: Definition

#### DBMS_IOT: Definition

#### DBMS_JAVA: Definition

#### DBMS_JOB: Definition

#### DBMS_LDAP: Definition

#### DBMS_LDAP_UTL: Definition

#### DBMS_LIBCACHE: Definition

#### DBMS_LOB: Definition

#### DBMS_LOCK: Definition

#### DBMS_LOGMNR: Definition

#### DBMS_LOGMNR_D: Definition

#### DBMS_LOGSTDBY: Definition

#### DBMS_METADATA: Definition

#### DBMS_MGWADM: Definition

#### DBMS_MGWMSG: Definition

#### DBMS_MONITOR: Definition

#### DBMS_MVIEW: Definition

#### DBMS_OBFUSCATION_TOOLKIT: Definition

#### DBMS_ODCI: Definition

#### DBMS_OFFLINE_OG: Definition

#### DBMS_OLAP: Definition

#### DBMS_OUTLN: Definition

#### DBMS_OUTLN_EDIT: Definition

#### DBMS_OUTPUT: Definition

#### DBMS_PCLXUTIL: Definition

#### DBMS_PIPE: Definition

#### DBMS_PREDICTIVE_ANALYTICS: Definition

#### DBMS_PREPROCESSOR: Definition

#### DBMS_PROFILER: Definition

#### DBMS_PROPAGATION_ADM: Definition

#### DBMS_RANDOM: Definition

#### DBMS_RECTIFIER_DIFF: Definition

#### DBMS_REDEFINITION: Definition

#### DBMS_REFRESH: Definition

#### DBMS_REPAIR: Definition

#### DBMS_REPCAT: Definition

#### DBMS_REPCAT_ADMIN: Definition

#### DBMS_REPCAT_INSTANTIATE: Definition

#### DBMS_REPCAT_RGT: Definition

#### DBMS_REPUTIL: Definition

#### DBMS_RESOURCE_MANAGER: Definition

#### DBMS_RESOURCE_MANAGER_PRIVS: Definition

#### DBMS_RESUMABLE: Definition

#### DBMS_RLMGR: Definition

#### DBMS_RLS: Definition

#### DBMS_ROWID: Definition

#### DBMS_RULE: Definition

#### DBMS_RULE_ADM: Definition

#### DBMS_SCHEDULER: Definition

#### DBMS_SERVER_ALERT: Definition

#### DBMS_SERVICE: Definition

#### DBMS_SESSION: Definition

#### DBMS_SHARED_POOL: Definition

#### DBMS_SPACE: Definition

#### DBMS_SPACE_ADMIN: Definition

#### DBMS_SQL: Definition

#### DBMS_SQLTUNE: Definition

#### DBMS_STATS: Definition

#### DBMS_STAT_FUNCS: Definition

#### DBMS_STORAGE_MAP: Definition

#### DBMS_STREAMS: Definition

#### DBMS_STREAMS_ADM: Definition

#### DBMS_STREAMS_AUTH: Definition

#### DBMS_STREAMS_MESSAGING: Definition

#### DBMS_STREAMS_TABLESPACE_ADM: Definition

#### DBMS_TDB: Definition

#### DBMS_TRACE: Definition

#### DBMS_TRANSACTION: Definition

#### DBMS_TRANSFORM: Definition

#### DBMS_TTS: Definition

#### DBMS_TYPES: Definition

#### DBMS_UTILITY: Definition

#### DBMS_WARNING: Definition

#### DBMS_WM: Definition

#### DBMS_WORKLOAD_REPOSITORY: Definition

#### DBMS_XDB: Definition

#### DBMS_XDBT: Definition

#### DBMS_XDBZ: Definition

#### DBMS_XDB_VERSION: Definition

#### DBMS_XMLDOM: Definition

#### DBMS_XMLGEN: Definition

#### DBMS_XMLPARSER: Definition

#### DBMS_XMLQUERY: Definition

#### DBMS_XMLSAVE: Definition

#### DBMS_XMLSCHEMA: Definition

#### DBMS_XMLSTORE: Definition

#### DBMS_XPLAN: Definition

#### DBMS_XSLPROCESSOR: Definition

#### DBTIMEZONE: Definition

#### DBURITYPE: Definition

#### DB_CONNECT_INFO Procedure: Definition

#### DB_VERSION Procedure: Definition

#### DEAUTHORIZE_DAD Procedure: Definition

#### DEBUG: Definition

#### DEBUG_EXTPROC: Definition

#### DEBUG_OFF Procedure: Definition

#### DEBUG_ON Procedure: Definition

#### DECLARE: Definition

#### DECLARE_REWRITE_EQUIVALENCE Procedures: Definition

#### DECODE: Definition

#### DECOMPOSE: Definition

#### DECRYPT Function: Definition

#### DECRYPT Procedures: Definition

#### DEFAULT: Definition

#### DEFAULT ROLE Clause: Definition

#### DEFAULT storage_clause: Definition

#### DEFAULT TABLESPACE Clause: Definition

#### DEFAULT TEMPORARY TABLESPACE Clause: Definition

#### DEFAULT_INDEX_PARAMETERS Procedure: Definition

#### DEFAULT_XPINDEX_PARAMETERS Procedure: Definition

#### DEFERRED: Definition

#### DEFINE: Definition

#### DEFINE_ANYDATA_ARGUMENT Procedure: Definition

#### DEFINE_ARRAY Procedure: Definition

#### DEFINE_CHAIN_EVENT_STEP Procedure: Definition

#### DEFINE_CHAIN_RULE Procedure: Definition

#### DEFINE_CHAIN_STEP Procedure: Definition

#### DEFINE_COLUMN Procedure: Definition

#### DEFINE_COLUMN_LONG Procedure: Definition

#### DEFINE_METADATA_ARGUMENT Procedure: Definition

#### DEFINE_PROGRAM_ARGUMENT Procedures: Definition

#### DEFRAG_INDEX Procedure: Definition

#### DEL: Definition

#### DELETE: Definition

#### DELETE Statement: Definition

#### DELETE STATISTICS: Definition

#### DELETEDATA Procedure: Definition

#### DELETERESOURCE Procedure: Definition

#### DELETERESOURCEMETADATA Procedures: Definition

#### DELETESCHEMA Procedure: Definition

#### DELETEXML: Definition

#### DELETE_ALL_ERRORS Procedure: Definition

#### DELETE_BREAKPOINT Function: Definition

#### DELETE_COLUMN Procedure: Definition

#### DELETE_COLUMN_STATS Procedure: Definition

#### DELETE_CONSUMER_GROUP Procedure: Definition

#### DELETE_DAD_ATTRIBUTE Procedure: Definition

#### DELETE_DATABASE_STATS Procedure: Definition

#### DELETE_DICTIONARY_STATS Procedure: Definition

#### DELETE_ERROR Procedure: Definition

#### DELETE_FIXED_OBJECTS_STATS Procedure: Definition

#### DELETE_GLOBAL_ATTRIBUTE Procedure: Definition

#### DELETE_INDEX_STATS Procedure: Definition

#### DELETE_OBJECT Procedure: Definition

#### DELETE_OER_BREAKPOINT Function: Definition

#### DELETE_PLAN Procedure: Definition

#### DELETE_PLAN_CASCADE Procedure: Definition

#### DELETE_PLAN_DIRECTIVE Procedure: Definition

#### DELETE_POLICY_GROUP Procedure: Definition

#### DELETE_RULE Procedure: Definition

#### DELETE_SCHEMA_STATS Procedure: Definition

#### DELETE_SERVICE Procedure: Definition

#### DELETE_SQLSET Procedure: Definition

#### DELETE_SQLWKLD Procedure: Definition

#### DELETE_SQLWKLD_REF Procedure: Definition

#### DELETE_SQLWKLD_STATEMENT Procedure: Definition

#### DELETE_SYSTEM_STATS Procedure: Definition

#### DELETE_TABLE_STATS Procedure: Definition

#### DELETE_TASK Procedure: Definition

#### DEL_ALIAS_FROM_LDAP Procedure: Definition

#### DENSE_RANK: Definition

#### DENY_ALL Procedure: Definition

#### DENY_SERVER Procedure: Definition

#### DEPTH: Definition

#### DEQUEUE Procedure: Definition

#### DEQUEUE_ARRAY Function: Definition

#### DEQUEUE_OPTIONS_T Type: Definition

#### DEREF: Definition

#### DEREGISTER Procedure: Definition

#### DESCRIBE: Definition

#### DESCRIBE_COLUMNS Procedure: Definition

#### DESCRIBE_COLUMNS2 Procedure: Definition

#### DESCRIBE_DIMENSION Procedure: Definition

#### DESCRIBE_PROCEDURE Procedure: Definition

#### DESC_REC, DESC_TAB: Definition

#### DETACH Procedure: Definition

#### DETACH_SESSION Procedure: Definition

#### DETACH_SIMPLE_TABLESPACE Procedure: Definition

#### DETACH_TABLESPACES Procedure: Definition

#### DETERMINISTIC: Definition

#### DETERMINISTIC Clause: Definition

#### DFN Function: Definition

#### DFN Procedure: Definition

#### DIRECTORY_OBJECT_SET Type: Definition

#### DIRLISTCLOSE Function: Definition

#### DIRLISTCLOSE Procedure: Definition

#### DIRLISTOPEN Function: Definition

#### DIRLISTOPEN Procedure: Definition

#### DISABLE Clause: Definition

#### DISABLE Procedure: Definition

#### DISABLE RESUMABLE: Definition

#### DISABLE_BREAKPOINT Function: Definition

#### DISABLE_DB_ACCESS Procedure: Definition

#### DISABLE_GROUPED_POLICY Procedure: Definition

#### DISABLE_HIERARCHY Procedure: Definition

#### DISABLE_POLICY Procedure: Definition

#### DISABLE_PROPAGATION_SCHEDULE Procedure: Definition

#### DISASSOCIATE STATISTICS: Definition

#### DISCONNECT: Definition

#### DISCONNECT SESSION Clause: Definition

#### DISCONNECT_SESSION Procedure: Definition

#### DISPLAY Function: Definition

#### DISPLAY_AWR Function: Definition

#### DISPLAY_CURSOR Function: Definition

#### DISPLAY_SQLSET Function: Definition

#### DISTINCT | UNIQUE: Definition

#### DIV Function: Definition

#### DIV Procedure: Definition

#### DLISTCLOSE Function: Definition

#### DLISTCLOSE Procedure: Definition

#### DLISTDEF Function: Definition

#### DLISTDEF Procedure: Definition

#### DLISTOPEN Function: Definition

#### DLISTOPEN Procedure: Definition

#### DLISTTERM Function: Definition

#### DLISTTERM Procedure: Definition

#### DOC[UMENT] (obsolete): Definition

#### DOWNGRADE Procedure: Definition

#### DOWNLOAD_FILE Procedures: Definition

#### DRIVING_SITE Hint: Definition

#### DROP: Definition

#### DROP Clause: Definition

#### DROP CLUSTER: Definition

#### DROP COLUMNS CONTINUE Clause: Definition

#### DROP CONTEXT: Definition

#### DROP DATABASE: Definition

#### DROP DATABASE LINK: Definition

#### DROP DIMENSION: Definition

#### DROP DIRECTORY: Definition

#### DROP DISKGROUP: Definition

#### DROP FUNCTION: Definition

#### DROP INDEX: Definition

#### DROP INDEXTYPE: Definition

#### DROP JAVA: Definition

#### DROP LIBRARY: Definition

#### DROP MATERIALIZED VIEW: Definition

#### DROP MATERIALIZED VIEW LOG: Definition

#### DROP OPERATOR: Definition

#### DROP OUTLINE: Definition

#### DROP PACKAGE: Definition

#### DROP PROCEDURE: Definition

#### DROP PROFILE: Definition

#### DROP RESTORE POINT: Definition

#### DROP ROLE: Definition

#### DROP ROLLBACK SEGMENT: Definition

#### DROP SEQUENCE: Definition

#### DROP SUPPLEMENTAL LOG Clause: Definition

#### DROP SYNONYM: Definition

#### DROP TABLE: Definition

#### DROP TABLESPACE: Definition

#### DROP TRIGGER: Definition

#### DROP TYPE: Definition

#### DROP TYPE BODY: Definition

#### DROP UNUSED COLUMNS Clause: Definition

#### DROP USER: Definition

#### DROP VIEW: Definition

#### DROPPREFERENCES Procedure: Definition

#### DROP_ALL Function: Definition

#### DROP_APPLY Procedure: Definition

#### DROP_AQ_AGENT Procedure: Definition

#### DROP_ATTRIBUTE_SET Procedure: Definition

#### DROP_BASELINE Procedure: Definition

#### DROP_BY_CAT Procedure: Definition

#### DROP_CAPTURE Procedure: Definition

#### DROP_CHAIN Procedure: Definition

#### DROP_CHAIN_RULE Procedure: Definition

#### DROP_CHAIN_STEP Procedure: Definition

#### DROP_CHANGE_SET Procedure: Definition

#### DROP_CHANGE_SOURCE Procedure: Definition

#### DROP_CHANGE_TABLE Procedure: Definition

#### DROP_DAD Procedure: Definition

#### DROP_EDIT_TABLES Procedure: Definition

#### DROP_ELEMENT Function: Definition

#### DROP_EVALUATION_CONTEXT Procedure: Definition

#### DROP_EVENT_STRUCTURE Procedure: Definition

#### DROP_FILE Function: Definition

#### DROP_FILE_GROUP Procedure: Definition

#### DROP_GROUPED_POLICY Procedure: Definition

#### DROP_JOB Procedure: Definition

#### DROP_JOB_CLASS Procedure: Definition

#### DROP_MODEL Procedure: Definition

#### DROP_OBJECT_DEPENDENCY: Definition

#### DROP_POLICY Procedure: Definition

#### DROP_POLICY_CONTEXT Procedure: Definition

#### DROP_PROGRAM Procedure: Definition

#### DROP_PROGRAM_ARGUMENT Procedures: Definition

#### DROP_PROPAGATION Procedure: Definition

#### DROP_QUEUE Procedure: Definition

#### DROP_QUEUE_TABLE Procedure: Definition

#### DROP_REWRITE_EQUIVALENCE Procedure: Definition

#### DROP_RULE Procedure: Definition

#### DROP_RULE_CLASS Procedure: Definition

#### DROP_RULE_SET Procedure: Definition

#### DROP_SCHEDULE Procedure: Definition

#### DROP_SNAPSHOT_RANGE Procedure: Definition

#### DROP_SQLSET Procedure: Definition

#### DROP_SQL_PROFILE Procedure: Definition

#### DROP_STAT_TABLE Procedure: Definition

#### DROP_SUBSCRIPTION Procedure: Definition

#### DROP_TRANSFORMATION Procedure: Definition

#### DROP_TUNING_TASK Procedure: Definition

#### DROP_UNUSED Procedure: Definition

#### DROP_VERSION Procedure: Definition

#### DROP_WINDOW Procedure: Definition

#### DROP_WINDOW_GROUP Procedure: Definition

#### DUMP: Definition

#### DUMP_ORPHAN_KEYS Procedure: Definition

#### DYNAMIC_SAMPLING Hint: Definition

Copyright © 2006, Oracle. All rights reserved.